SELECT id,titeldt,foto from viennawalks_walks WHERE (titeldt LIKE '% Tiere%' or textdt LIKE '% Tiere%' or keyword LIKE '% Tiere%') AND id in (SELECT tour from viennawalks_termine where datum>='2024-04-29' group by tour) order by titeldt ASC